﻿-- =====================================================
-- Author:			Saghari, Farid
-- Create date:		1390/01/26
-- Description:     Delete banks by a field value
-- =====================================================
CREATE PROCEDURE [uspBankDeleteByField]
	@fieldName nvarchar(100),
	@value nvarchar(1000)
AS
BEGIN
	DECLARE @query nvarchar(2000)
	SET @query = 'DELETE FROM [Bank] WHERE [' + @FieldName + '] = ''' + @value + ''''
	EXEC(@query)
END